PRINT 'Server:' + @@SERVERNAME + ' Database:'+convert(nvarchar,DB_NAME ( )) ; DECLARE @result int = 0; IF EXISTS (SELECT 1 FROM [INFORMATION_SCHEMA].[TABLES] where TABLE_NAME in ('Flag') AND TABLE_SCHEMA='System') EXEC sp_executesql N'SET @result=0; SET @result = isnull((SELECT 1 FROM [System].[Flag] D WHERE Flag=''ThumbPrint''), 0) ', N'@result int output', @result=@result output; IF (@result=1) -- databasen er en Datatransport BEGIN EXEC ('print ''Databasen er af typen datatransport klient database.''; DECLARE @ServiceURL [Unicode1024], @ThumbPrint [Unicode1024], @Result int = 0; EXEC [System].[HentIkkeTomtFlag] @Flag = N''ServiceURL'', @FlagVarcharVaerdi = @ServiceURL out; EXEC [System].[HentIkkeTomtFlag] @Flag = N''ThumbPrint'', @FlagVarcharVaerdi = @ThumbPrint out; PRINT ''Gammel-værdi:'' + @@SERVERNAME + '':''+convert(nvarchar,DB_NAME ( )) +'':'' +@ThumbPrint; EXEC [System].[GemFlag] @Flag = N''ThumbPrint'', @FlagBitVaerdi=0, @FlagVarcharVaerdi=N''86798E0E1FE000FDEFEC7C5E953BCB780D6EA821;9BFFA7E5F577DB04BCAC89833260BA60BABFE53D'', @DefaultVaerdi=N'''', @Beskrivelse=N''Anvendes til at verificere korrekt SSL certifikat'', @Opdaterbar=1, @Overwrite=1; EXEC [System].[HentIkkeTomtFlag] @Flag = N''ThumbPrint'', @FlagVarcharVaerdi = @ThumbPrint out; PRINT ''Ny-værdi:'' + @@SERVERNAME + '':''+convert(nvarchar,DB_NAME ( )) +'':'' +@ThumbPrint; EXECUTE @Result = [CLR].[CheckSSLThumbprint] @ServiceURL, @ThumbPrint IF not (@Result = 1) print ''Ukendt certifikat (nye) på serviceurl.''; else print ''Nye virker.''; '); END IF (@result = 0) PRINT N'Bemærk ' + convert(nvarchar(256),DB_NAME ( )) + N' ikke er genkendt som Datatransport database. Så intet blev rettet.';